/*
 Navicat Premium Data Transfer

 Source Server         : 仲法网
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : app.zzzczfw.com:3306
 Source Schema         : vast

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 26/05/2021 23:03:03
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for contract_detail_signature
-- ----------------------------
DROP TABLE IF EXISTS `contract_detail_signature`;
CREATE TABLE `contract_detail_signature` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `contract_id` bigint(20) DEFAULT NULL,
  `contract_detail_id` bigint(20) DEFAULT NULL,
  `type` int(2) DEFAULT NULL COMMENT '签名/签章类型（1企业 2客户 3第三方/丙方）',
  `part_name` varchar(30) DEFAULT NULL COMMENT '合同签署方（债权人，债务人，共同债务人）',
  `page` int(3) DEFAULT NULL COMMENT '合同页数',
  `x` varchar(20) DEFAULT NULL COMMENT '签章坐标x',
  `y` varchar(20) DEFAULT NULL COMMENT '签章坐标y',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of contract_detail_signature
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
